<!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title> - 亲友圈 牌局统计</title>
	<meta name="keywords" content="">
	<meta name="description" content="">
	<!--<link rel="shortcut icon" href="favicon.ico"> <link href="__STATIC__/css/bootstrap.min.css?v=3.3.6" rel="stylesheet">
	<link href="__STATIC__/css/font-awesome.css?v=4.4.0" rel="stylesheet">
	<link href="__STATIC__/css/plugins/jqgrid/ui.jqgrid.css?0820" rel="stylesheet">
	<link href="__STATIC__/css/animate.css" rel="stylesheet">
	<link href="__STATIC__/css/style.css?v=4.1.0" rel="stylesheet">
	<link href="__STATIC__/css/new_file.css" rel="stylesheet">-->
	<link rel="shortcut icon" href="favicon.ico"> <link href="__STATIC__/css/bootstrap.min.css" rel="stylesheet">
	<link href="__STATIC__/css/font-awesome.css?v=4.4.0" rel="stylesheet">
	<link href="__STATIC__/css/plugins/jqgrid/ui.jqgrid.css?0820" rel="stylesheet">
	<link href="__STATIC__/css/animate.css" rel="stylesheet">
	<link href="__STATIC__/css/style.css?v=4.1.0" rel="stylesheet">
	<link href="__STATIC__/css/new_file.css" rel="stylesheet">
</head>
<body class="gray-bg">
<div class="wrapper wrapper-content  animated fadeInRight">
	<div class="row">
		<div class="col-sm-12">
			<div class="ibox ">
				<div class="ibox-title">
					<h5>亲友圈 牌局统计</h5>

				</div>
				<div class="toogl_body">
					<div class="toogl_tale">
						<a href="dataclub"><input type="button" value="亲友圈列表" class="btn btn-w-m btn-default"></a>
						<a href="dataclub_2"><input type="button" value="蓝钻耗钻统计" class="btn btn-w-m btn-info"></a>
						<!--<a href="dataclub_3"><input type="button" value="钻石消耗子表" class="btn btn-w-m btn-default"></a>-->
						<a href="dataclub_4"><input type="button" value="会员卡销售" class="btn btn-w-m btn-default"></a>
						<a href="dataclub_5"><input type="button" value="黄钻统计" class="btn btn-w-m btn-default"></a>
					</div><br/>
					<div class="ibox-content ibox-jqGrid">
                    	<p>
                    		选择时间段：<input type="text" id="time" class="input-ys" readonly="readonly">
							亲友圈id：<input type="text" id="club_id" class="input-ys" >
                    		<input type="button" value="确定" class="input-anniu" id="buttonid">
						<span id="count"></span>
                    	</p>
						<div class="jqGrid_wrapper">
							<table id="table_list_1"></table>
							<div id="pager_list_1"></div>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>
</div>

<!--开桌人数-->
<div id="myModal" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
	<div id="gray_Nr">
		<div class="col-zm-j col-zm-j2">
			<div class="ibox ibox-wid">
				<div class="ibox-title">
					<h5>消息提示</h5>
					<div class="ibox-tools" data-dismiss="modal">
						<a class="close-link">
							<i class="fa fa-times"></i>
						</a>
					</div>
				</div>
				<div class="ibox-s ibox-s-zj" id="a">
					<p class="data-p">蓟县麻将：5局</p>
					<p class="data-p">蓟县麻将：5局</p>
					<p class="data-p">蓟县麻将：5局</p>
				</div>
				<div class="ibox-butz">
					<input class="btn btn-w-m btn-info" type="button" data-dismiss="modal" value="確定">
					<input class="btn btn-w-m" type="button" data-dismiss="modal" value="取消">
				</div>
			</div>
		</div>
	</div>
</div>

<!--参与人数-->
<div id="myModal2" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
	<div id="gray_Nr">
		<div class="col-zm-j col-zm-j2">
			<div class="ibox ibox-wid">
				<div class="ibox-title">
					<h5>消息提示</h5>
					<div class="ibox-tools" data-dismiss="modal">
						<a class="close-link">
							<i class="fa fa-times"></i>
						</a>
					</div>
				</div>
				<div class="ibox-s ibox-s-zj" id="a">
					<p class="data-p">蓟县麻将：5人</p>
					<p class="data-p">蓟县麻将：5人</p>
					<p class="data-p">蓟县麻将：5人</p>
				</div>
				<div class="ibox-butz">
					<input class="btn btn-w-m btn-info" type="button" data-dismiss="modal" value="確定">
					<input class="btn btn-w-m" type="button" data-dismiss="modal" value="取消">
				</div>
			</div>
		</div>
	</div>
</div>
<!--手机导航-->
<div class="to-fdh" style="display: none;">
	<img class="to-imgd" src="__STATIC__/img/phonedh.jpg">
	<div class="mob-nrlb">
		<ul>
			<li>
				<a class="mob-nrdh">管理</a>
				<ul class="mob-nryc">
					<li class="mob-nrdhli">
						<a href="{:url('Player/gameplayer')}">玩家管理</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('system/notice')}">公告管理</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('email/mail')}">邮件管理</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('Club/club')}">亲友圈管理</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('Money/money')}">提现管理</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('Order/order')}">订单管理</a>
					</li>
				</ul>
			</li>
			<li>
				<a class="mob-nrdh">数据</a>
				<ul class="mob-nryc">
					<li class="mob-nrdhli">
						<a href="{:url('data/datagk')}">概況</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('data/datawf')}">玩法</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('data/datalc')}">留存</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('data/datass')}">实时数据</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('data/dataczfx')}">充值分析</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('data/dataclub')}">亲友圈统计</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('data/president')}">高级会长</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('data/regionaldata')}">地区数据</a>
					</li>
				</ul>
			</li>
			<li>
				<a class="mob-nrdh mob-qbh">权限</a>
				<ul class="mob-nryc">
					<li class="mob-nrdhli">
						<a href="{:url('rule/rule_list')}">权限管理</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('rule/rule_group')}">用户组管理</a>
					</li>
					<li class="mob-nrdhli">
						<a href="{:url('account/account_details')}">后台账号管理</a>
					</li>
				</ul>
			</li>
		</ul>
	</div>
</div>
<div id="zkbg">
	<img src="__STATIC__/img/dp.gif">
</div>
<div class="vnl-zz" style="display:none">
	<div><img src="__STATIC__/img/bqhp.gif"></div>
</div>
<!--手机适配-->
<script src="__STATIC__/js/jquery.min.js?v=2.1.4"></script>
<script src="__STATIC__/js/bootstrap.min.js?v=3.3.6"></script>
<script src="__STATIC__/js/plugins/peity/jquery.peity.min.js"></script>
<script src="__STATIC__/js/plugins/jqgrid/i18n/grid.locale-cn.js?0820"></script>
<script src="__STATIC__/js/plugins/jqgrid/jquery.jqGrid.min.js?0820"></script>
<script src="__STATIC__/js/content.js?v=1.0.0"></script>
<script src="__STATIC__/js/plugins/laydate/laydate.js"></script>
<script src="__STATIC__/js/echarts.min.js"></script>
<script src="__STATIC__/js/echarts.common.min.js"></script>
<script>
    //手机适配
    $(function(){
        if ((navigator.userAgent.match(/(phone|pad|pod|iPhone|iPod|ios|iPad|Android|Mobile|BlackBerry|IEMobile|MQQBrowser|JUC|Fennec|wOSBrowser|BrowserNG|WebOS|Symbian|Windows Phone)/i))) {
            $("head").append("<link>");
            var css = $("head").children(":last");
            css.attr({
                rel:  "stylesheet",
                type: "text/css",
                href: "__STATIC__/css/phone_sp.css"
            });
            var mql = window.matchMedia("(orientation: portrait)");
            if(mql.matches) { //竖屏样式
                $(".vnl-zz").show();
                $(".to-fdh").hide();
            }else{
                $(".to-fdh").show();
                $("html").width("100%");
                $("body").width("100%");
            }
            mql.addListener(function(m) {
                if(m.matches) {
                    // 改变到直立方向
                    $(".vnl-zz").show();
                    $(".to-fdh").hide();
                }
                else {
                    $(".to-fdh").show();
                    $(".vnl-zz").hide();
                    $("html").width("100%");
                    $("body").width("100%");
                }
            });
        }
    });
    //导航显示展开
    $(".mob-nrdh").click(function(){
        $(this).next().toggle(".mob-nryc");
    });
    $(".to-imgd").click(function(){
        $(this).next().toggle(".mob-nrlb");
    });
    function DateDiff(sDate1, sDate2) {  //sDate1和sDate2是yyyy-MM-dd格式

        var aDate, oDate1, oDate2, iDays;
        aDate = sDate1.split("-");
        oDate1 = new Date(aDate[1] + '-' + aDate[2] + '-' + aDate[0]);  //转换为yyyy-MM-dd格式
        aDate = sDate2.split("-");
        oDate2 = new Date(aDate[1] + '-' + aDate[2] + '-' + aDate[0]);
        iDays = parseInt(Math.abs(oDate1 - oDate2) / 1000 / 60 / 60 / 24); //把相差的毫秒数转换为天数

        return iDays;  //返回相差天数
    }
    //手机适配end
    var mydata = [];
    $('#buttonid').on('click', function() {     //页面上的button按钮的click事件，重新获取参数后发送参数，然后重新加载数据。
        var time = $("#time").val();
        // $("#datetime").html(time);
        var start_time = time.substring(0,10);
        var end_time = time.substring(13);
        var day = DateDiff(start_time,end_time)+1;
        // $("#day").html(time);
        console.log(day);
        var club_id = $("#club_id").val();
    	if(time == ""){
        	alert("请选择时间");
        	return false;
           }
    	if(club_id == ""){
        	alert("请输入亲友圈id");
        	return false;
           }
        $.ajax({
            url: '__URL__/Hand',
            data: {
                "start_time": start_time, //开始日期
                "end_time":end_time, // 结束日期
                'club_id':club_id,
            },
            dataType: "json",
            type: "post",
            success: function(e) {
                var pay_gold_num = 0;
                var free_gold_num = 0;
                $("#table_list_1").jqGrid("clearGridData");
                for(i  in e ){
                    mydata = {
                        datetime: e[i].datetime, //时间
                        club_id: e[i].club_id,
                        club_name: e[i].club_name,
                        create_room_num: e[i].create_room_num,
                        valid_user_num: e[i].valid_user_num,
                        reduce_pay_gold_num: e[i].reduce_pay_gold_num,
                        reduce_free_gold_num: e[i].reduce_free_gold_num,

                    };
                    $("#table_list_1").addRowData(i, mydata, "last");
                    var pay_gold_num = pay_gold_num+parseInt(e[i].reduce_pay_gold_num);
                    var free_gold_num = free_gold_num+parseInt(e[i].reduce_free_gold_num);
                }
                $("#count").html('<span style="font-weight:bold ;color:red">'+time+'</span> 共计：<span style="font-weight:bold ;color:red">'+day+'</span>天，耗赠送蓝钻：<span style="font-weight:bold ;color:red">'+free_gold_num+'</span>,耗充值蓝钻：<span style="font-weight:bold; color:red">'+pay_gold_num+'</span>');
            }

            });

        // $("#table_list_1").jqGrid('setGridParam',{
        //     url:'__URL__/Hand',
        //     datatype:'json',
        //     postData:{
        //         'start_time':start_time,
        //         'end_time':end_time,
        //         'club_id':club_id,
        //     },
        //     page:1
        // }).trigger("reloadGrid"); //重新载入

    });
  $(document).ready(function () {
            $.jgrid.defaults.styleUI = 'Bootstrap';
            $("#table_list_1").jqGrid({
                data: mydata,
                datatype: "local",
                height: 250,
                // url:'__URL__/club_list',
                // datatype:'json',
                // postData:{}, //发送数据
                mtype: 'POST',
                height: 500,
                autowidth: true,
                shrinkToFit: true,
                rowNum: 20,
                rowList: [20,50,100],
                colNames: ['时间', '亲友圈ID', '亲友圈名称', '桌开桌数', '参与人数','消耗充值蓝钻数','消耗赠送蓝钻数'],
                colModel: [
                    {
                        name: 'datetime',
                        index: 'datetime',
                        width: 60,
                        align:"center"
                    },
                    {
                        name: 'club_id',
                        index: 'club_id',
                        width: 60,
                        sorttype: "int",
                        align:"center"
                    },
                    {
                        name: 'club_name',
                        index: 'club_name',
                        width: 90,
                        align:"center"
                    },
                    {
                        name: 'create_room_num',
                        index: 'create_room_num',
                        width: 100,
                        align:"center"
                    },
                    {
						name: 'valid_user_num',
						index: 'valid_user_num',
						width: 60,
                        align:"center"
					},
                    {
						name: 'reduce_pay_gold_num',
						index: 'reduce_pay_gold_num',
						width: 60,
                        align:"center"
					},
                	 {
						name: 'reduce_free_gold_num',
						index: 'reduce_free_gold_num',
						width: 60,
                        align:"center"
					},

                ],
                pager: "#pager_list_1",
                viewrecords: true,
                caption: "亲友圈列表",
                loadonce: true,
                hidegrid: false
            });

        
		setTimeout(function(){
            var width = $('.jqGrid_wrapper').width();
            $('#table_list_1').setGridWidth(width);
		},500);
        
        
        });
  
	laydate.render({
	  elem: '#time',
	  range: true
	});
</script>
</body>

</html>